/*
Navicat SQL Server Data Transfer

Source Server         : localhostSQLserver
Source Server Version : 110000
Source Host           : localhost:1433
Source Database       : gzzOFin
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2017-06-18 14:30:38
*/


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE [dbo].[sys_user]
GO
CREATE TABLE [dbo].[sys_user] (
[id] varchar(50) NULL ,
[name] varchar(255) NULL DEFAULT NULL ,
[age] int NULL ,
[test] varchar(255) NULL 
)


GO

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'5bc3a68d922f4a6aab57226999e48669876154981698203649', N'交警', N'30', N'test')
GO
GO
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'784972358981328902', N'Tom', N'240', null)
GO
GO
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'784972358981328903', N'Jammy', N'21', null)
GO
GO
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'874815835645222912', N'dd', N'333999', null)
GO
GO
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'874820499115667456', N'55', N'555', null)
GO
GO
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'9bc85489575c4ae7933148d860627d0b8754096608944', N'test', N'100', null)
GO
GO
INSERT INTO [dbo].[sys_user] ([id], [name], [age], [test]) VALUES (N'24d67ff2716b416f8cc9431505cb29bd876210067879194625', N'交警', N'30', N'test')
GO
GO

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE [dbo].[users]
GO
CREATE TABLE [dbo].[users] (
[id] bigint NOT NULL IDENTITY(1,1) ,
[userName] nvarchar(32) NULL ,
[passWord] nvarchar(32) NULL ,
[user_sex] nvarchar(32) NULL ,
[nick_name] nvarchar(32) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[users]', RESEED, 21)
GO

-- ----------------------------
-- Records of users
-- ----------------------------
SET IDENTITY_INSERT [dbo].[users] ON
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'7', N'aa', N'a123456', N'MAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'8', N'bb', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'9', N'cc', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'10', N'aa', N'a123456', N'MAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'11', N'bb', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'12', N'cc', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'13', N'aa', N'a123456', N'MAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'14', N'bb', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'15', N'cc', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'16', N'aa', N'a123456', N'MAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'17', N'bb', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'18', N'cc', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'19', N'aa', N'a123456', N'MAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'20', N'bb', N'b123456', N'WOMAN', null)
GO
GO
INSERT INTO [dbo].[users] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'21', N'cc', N'b123456', N'WOMAN', null)
GO
GO
SET IDENTITY_INSERT [dbo].[users] OFF
GO

-- ----------------------------
-- Table structure for userTest
-- ----------------------------
DROP TABLE [dbo].[userTest]
GO
CREATE TABLE [dbo].[userTest] (
[id] varchar(50) NOT NULL ,
[userName] nvarchar(255) NULL ,
[passWord] nvarchar(255) NULL ,
[user_sex] nvarchar(255) NULL ,
[nick_name] nvarchar(255) NULL 
)


GO

-- ----------------------------
-- Records of userTest
-- ----------------------------
INSERT INTO [dbo].[userTest] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'08cb62e1813a4eb5820c5bfd29ee6842876232502846386176', N'dachao', N'123456', N'MAN', N'jiaojing')
GO
GO
INSERT INTO [dbo].[userTest] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'25552164a9a94dca97f1ba28c21e9b0c876232502867357696', N'dachao', N'123456', N'MAN', N'jiaojing')
GO
GO
INSERT INTO [dbo].[userTest] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'69e0bddc5404402692a80eb791bf95d0876232502858969088', N'dachao', N'123456', N'MAN', N'jiaojing')
GO
GO
INSERT INTO [dbo].[userTest] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'd2284fc58dfc4edfb31560dea36c369b876232499298004992', N'dachao', N'123456', N'MAN', N'jiaojing')
GO
GO
INSERT INTO [dbo].[userTest] ([id], [userName], [passWord], [user_sex], [nick_name]) VALUES (N'd723432f73624be4a1454170af023ff6876232502854774784', N'dachao', N'123456', N'MAN', N'jiaojing')
GO
GO

-- ----------------------------
-- Indexes structure for table users
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table users
-- ----------------------------
ALTER TABLE [dbo].[users] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table userTest
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table userTest
-- ----------------------------
ALTER TABLE [dbo].[userTest] ADD PRIMARY KEY ([id])
GO
